package com.hujesse.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hujesse.pojo.GoodsVO;
import com.hujesse.pojo.Sure;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SureMapper extends BaseMapper<Sure> {
    // generic 中加入Sure类是为了在数据库中查找对应的表名称
    // @Select("SELECT  su.*,pg.goodsName from sure as su,pickupgoodsinfo as pg where su.id = pg.id and su.id =#{id}")
    List<GoodsVO> good(Integer id);
}
